
SELECT VENDEDOR, CODIGO_FILIAL, NOME_VENDEDOR, DATA_DESATIVACAO FROM LOJA_VENDEDORES 
WHERE VENDEDOR in ('c828','X577','B803','C143','C142','C909','D053','9695','C156','C170','B980','B820','C335','B635',
'9168','X426','7549','C160','C202','C399','2367','C897','C303','D038','C275','D023','B819','C861','9861','C828','C408',
'X463','C999')


/*
UPDATE LOJA_VENDEDORES  SET DATA_DESATIVACAO = '2008-04-25' 
WHERE VENDEDOR IN ('X577')
/*

/*
UPDATE CLIENTES_VAREJO   SET STATUS = '2' 
WHERE CODIGO_CLIENTE IN ('c828')
/*